package de.bahn.dbs.diva.db;

import android.net.Uri;
import android.provider.BaseColumns;

public interface Auftrag extends BaseColumns {

	String MIME_TYPE_DIR = "vnd.android.cursor.dir/vnd.de.diva.auftrag";

	String MIME_TYPE_ITEM = "vnd.android.cursor.item/vnd.de.diva.auftrag";

	String GLEIS = "gleis";

	String VERBUND = "verbund";

	String POSITION = "position";

	String FAHRZEUG_NR = "fz_nr";

	String LOCKED = "locked";

	String DEFAULT_SORT_ORDER = GLEIS + " ASC";

	String[] PROJECTION = { _ID, GLEIS, VERBUND, POSITION,
			FAHRZEUG_NR };

	interface CONTENT_URIS {
		Uri BASE = Uri.parse("content://de.bahn.dbs.diva/auftrag");

		Uri NACH_AUFTRAG = Uri.withAppendedPath(BASE, "aid");
	}

	interface SQL {
		String TABLE = "auftrag";

		String CREATE_CODE = "CREATE TABLE " + TABLE + " (" + _ID
				+ " INTEGER PRIMARY KEY AUTOINCREMENT, " + GLEIS
				+ " INTEGER NOT NULL, " + VERBUND + " TEXT, " + POSITION
				+ " INTEGER NOT NULL, " + FAHRZEUG_NR + " STRING, " + LOCKED
				+ " INTEGER NOT NULL);";

		String DROP_CODE = "DROP TABLE IF EXISTS " + TABLE + ";";

	}

}
